<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="com.db.conn"%>
<%@ page import="java.sql.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>


<jsp:include flush="true" page="${basePath}/admin/head.jsp"></jsp:include>
 <div class="panel panel-primary">
            <div class="panel-heading">
                <h3 class="panel-title">查看评价信息</h3>
            </div>
            <div class="panel-body" style="min-height: 500px;">
           <table style="width:100%;"><tr><td align="center">

					  <table  style="width:98%;margin-left:10px;" align="center">
                    <tbody>
                        <% 			conn cn=new conn();
    
     			String id = request.getParameter("id");
				String sql = "select  a.*,b.rname from assesss a  left join roomtype b on a.rid=b.rid  where aid=" + id ;
				ResultSet rs = cn.query(sql);
				rs.next();
			%>
 <tr>
	<td height="25" width="20%" align="right">订单编号：</td>
	<td height="25" width="*" align="left" style="text-align:left"><%=rs.getString("rno") %></td>
	</tr>
 <tr>
	<td height="25" width="20%" align="right">房型：</td>
	<td height="25" width="*" align="left" style="text-align:left"><%=rs.getString("rname") %></td>
	</tr>
 <tr>
	<td height="25" width="20%" align="right">评分：</td>
	<td height="25" width="*" align="left" style="text-align:left"><%=rs.getString("pj") %></td>
	</tr>
 <tr>
	<td height="25" width="20%" align="right">评语：</td>
	<td height="25" width="*" align="left" style="text-align:left"><%=rs.getString("pjnr")==null?"":rs.getString("pjnr") %></td>
	</tr>

						<tr>
							<td height="25" width="20%" align="right">图片：</td>
							<td height="25" width="*" align="left" style="text-align:left">

								<%
									ResultSet rs2=cn.query("select * from photo where  aid="+id);
									while (rs2.next()){
								%>
								<img src="<%=path%>/<%=rs2.getString("addr")%>" style="width: 230px;height: 180px;padding: 10px">
								<%}%>
							</td>
						</tr>
 <tr>
	<td height="25" width="20%" align="right">客户ID：</td>
	<td height="25" width="*" align="left" style="text-align:left"><%=rs.getString("mid") %></td>
	</tr>
 <tr>
	<td height="25" width="20%" align="right">评价时间：</td>
	<td height="25" width="*" align="left" style="text-align:left"><%=rs.getString("atime") %></td>
	</tr>


    <tr>
        <td>&nbsp;</td>
        <td align="left">
  
    <input name="btnReturn" type="button" value="返 回" class="btn btn-info"  onclick="history.go(-1);"  />
    
               </td>
    </tr>
                    </tbody>
                </table>

					<%
				if (rs != null)
					rs.close();
				if (cn != null)
					cn.close();
			%>
   </td></tr></table>
            

            </div>
        </div>


